package com.yixun.show.mapper;

import com.yixun.entity.DiQu;
import com.yixun.entity.Dict;
import com.yixun.entity.YxDept;
import com.yixun.lbx.entity.YxProBeeSwarm;
import com.yixun.lbx.entity.YxProCompany;
import com.yixun.lbx.entity.YxProProductInfo;
import com.yixun.lbx.entity.YxProProductYield;

import java.util.List;

public interface ShowMapper {


    List<YxProProductInfo> findProductInfo();

    List<YxProProductYield> findProductYield(String dict_code);

    List<Dict> findProductType();

    List<YxProProductInfo> findComponent();

    int findComponentNum(String component);

    int findBeeSwarmTotalNum();

    List<YxProBeeSwarm> findBeeSwarmType();

    Integer findBeeSwarmNum(String beeType);

    List<YxProProductInfo> findProductPrice(int year, String dict_code);

    List<Dict> findCompanyType();

    List<DiQu> findDqCode();

    Integer findCompanyNum(String dict_name, Long dq_id);

    int findCompanyTotalNum(String s);

    double findTotalOutput();

    Double findOldYearAvgPrice(int oldYear, int pro_type);

    List<YxProCompany> findAllCompanyList();

    int findBeeHiveNum(Long qyId);

    YxProCompany getQyData(String brand);
}
